/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50542
 Source Host           : localhost
 Source Database       : money

 Target Server Type    : MySQL
 Target Server Version : 50542
 File Encoding         : utf-8

 Date: 08/10/2015 09:30:03 AM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `money_account`
-- ----------------------------
DROP TABLE IF EXISTS `money_account`;
CREATE TABLE `money_account` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `title` varchar(255) DEFAULT NULL COMMENT '账户名称',
  `amount` varchar(255) DEFAULT NULL,
  `time` varchar(255) DEFAULT NULL,
  `display` char(1) NOT NULL DEFAULT '1' COMMENT '数据状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `money_account`
-- ----------------------------
BEGIN;
INSERT INTO `money_account` VALUES ('1', '支付宝', '-100', '111', '1'), ('2', '现金', '300', '111', '1'), ('3', '招商银行-储蓄卡', '100', '1439109024', '1'), ('4', '招商银行-储蓄卡', '100', '1439109043', '0');
COMMIT;

-- ----------------------------
--  Table structure for `money_cat`
-- ----------------------------
DROP TABLE IF EXISTS `money_cat`;
CREATE TABLE `money_cat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `pid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `money_cat`
-- ----------------------------
BEGIN;
INSERT INTO `money_cat` VALUES ('1', '收入', '0'), ('2', '支出', '0');
COMMIT;

-- ----------------------------
--  Table structure for `money_detail`
-- ----------------------------
DROP TABLE IF EXISTS `money_detail`;
CREATE TABLE `money_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account` int(11) DEFAULT NULL,
  `cat` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `time` varchar(255) DEFAULT NULL,
  `display` char(1) NOT NULL DEFAULT '1' COMMENT '数据状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `money_detail`
-- ----------------------------
BEGIN;
INSERT INTO `money_detail` VALUES ('1', '2', '2', '-26', '11', '1'), ('2', '2', '2', '22', '1439008830', '1'), ('3', '2', '2', '333', '1439008890', '1'), ('4', '2', '2', '333', '1439008924', '1'), ('5', '1', '1', '2222', '1439008949', '1'), ('6', '1', '1', '222', '1439008991', '1'), ('7', '1', '1', '222', '1439009345', '1'), ('8', '1', '1', '222', '1439009373', '1'), ('9', '1', '1', '222', '1439009388', '1'), ('10', '1', '1', '2222', '1439009393', '1'), ('11', '1', '1', '100', '1439010723', '1'), ('12', '1', '1', '-300', '1439010730', '1'), ('13', '2', '1', '200', '1439010789', '1');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
